Page Control Search – Dynamics 365 BC Table Reference

SELECT p.ID ,p.Name ,pc.ControlName ,post.post_name FROM azrcrv_PageControls AS pc INNER JOIN azrcrv_Pages AS p ON p.ID = pc.PageNo INNER JOIN bct_posts AS post ON post.post_title = p.Name WHERE pc.ControlName = 'Ship-to Post Code' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to SHIP-TO POST CODE

Seq No	Page Number	Page Name	Control Name
1	1	Company Information	Ship-to Post Code
2	1	Company Information	Ship-to Post Code
3	41	Sales Quote	Ship-to Post Code
4	42	Sales Order	Ship-to Post Code
5	43	Sales Invoice	Ship-to Post Code
6	45	Sales List	Ship-to Post Code
7	49	Purchase Quote	Ship-to Post Code
8	50	Purchase Order	Ship-to Post Code
9	51	Purchase Invoice	Ship-to Post Code
10	52	Purchase Credit Memo	Ship-to Post Code
11	53	Purchase List	Ship-to Post Code
12	88	Job Card	Ship-to Post Code
13	130	Posted Sales Shipment	Ship-to Post Code
14	132	Posted Sales Invoice	Ship-to Post Code
15	134	Posted Sales Credit Memo	Ship-to Post Code
16	136	Posted Purchase Receipt	Ship-to Post Code
17	138	Posted Purchase Invoice	Ship-to Post Code
18	140	Posted Purchase Credit Memo	Ship-to Post Code
19	142	Posted Sales Shipments	Ship-to Post Code
20	143	Posted Sales Invoices	Ship-to Post Code
21	144	Posted Sales Credit Memos	Ship-to Post Code
22	145	Posted Purchase Receipts	Ship-to Post Code
23	146	Posted Purchase Invoices	Ship-to Post Code
24	147	Posted Purchase Credit Memos	Ship-to Post Code
25	507	Blanket Sales Order	Ship-to Post Code
26	509	Blanket Purchase Order	Ship-to Post Code
27	5159	Sales Order Archive	Ship-to Post Code
28	5161	Sales List Archive	Ship-to Post Code
29	5162	Sales Quote Archive	Ship-to Post Code
30	5164	Purchase Quote Archive	Ship-to Post Code
31	5166	Purchase List Archive	Ship-to Post Code
32	5167	Purchase Order Archive	Ship-to Post Code
33	5900	Service Order	Ship-to Post Code
34	5933	Service Invoice	Ship-to Post Code
35	5935	Service Credit Memo	Ship-to Post Code
36	5964	Service Quote	Ship-to Post Code
37	5971	Posted Service Credit Memos	Ship-to Post Code
38	5972	Posted Service Credit Memo	Ship-to Post Code
39	5974	Posted Service Shipments	Ship-to Post Code
40	5975	Posted Service Shipment	Ship-to Post Code
41	5977	Posted Service Invoices	Ship-to Post Code
42	5978	Posted Service Invoice	Ship-to Post Code
43	5980	Service Item Card	Ship-to Post Code
44	6050	Service Contract	Ship-to Post Code
45	6053	Service Contract Quote	Ship-to Post Code
46	6072	Filed Service Contract	Ship-to Post Code
47	6620	Blanket Sales Order Archive	Ship-to Post Code
48	6622	Blanket Sales Order Archives	Ship-to Post Code
49	6623	Blanket Purchase Order Archive	Ship-to Post Code
50	6625	Blanket Purch. Order Archives	Ship-to Post Code
51	6627	Sales Return Order Archive	Ship-to Post Code
52	6629	Sales Return List Archive	Ship-to Post Code
53	6630	Sales Return Order	Ship-to Post Code
54	6640	Purchase Return Order	Ship-to Post Code
55	6644	Purchase Return Order Archive	Ship-to Post Code
56	6646	Purchase Return List Archive	Ship-to Post Code
57	6650	Posted Return Shipment	Ship-to Post Code
58	6652	Posted Return Shipments	Ship-to Post Code
59	6660	Posted Return Receipt	Ship-to Post Code
60	6662	Posted Return Receipts	Ship-to Post Code
61	9300	Sales Quotes	Ship-to Post Code
62	9301	Sales Invoice List	Ship-to Post Code
63	9302	Sales Credit Memos	Ship-to Post Code
64	9303	Blanket Sales Orders	Ship-to Post Code
65	9304	Sales Return Order List	Ship-to Post Code
66	9305	Sales Order List	Ship-to Post Code
67	9306	Purchase Quotes	Ship-to Post Code
68	9307	Purchase Order List	Ship-to Post Code
69	9308	Purchase Invoices	Ship-to Post Code
70	9309	Purchase Credit Memos	Ship-to Post Code
71	9310	Blanket Purchase Orders	Ship-to Post Code
72	9311	Purchase Return Order List	Ship-to Post Code
73	9346	Purchase Quote Archives	Ship-to Post Code
74	9347	Purchase Order Archives	Ship-to Post Code
75	9348	Sales Quote Archives	Ship-to Post Code
76	9349	Sales Order Archives	Ship-to Post Code

Dynamics 365 BC Table ReferencePage Control Search